/*
Author: Siddhartha
Date: 8/18/2016
Purpose: Removing potentially sensitive info from the datasets for submission to 3ie
*/

clear
set more off

cd "C:\Users\siddhartha\Dropbox\OA Incentives Data Final"

*PATIENT SURVEY (ALL)*

use "Patient Surveys\patient_survey.dta"

*Variables to drop in patient survey

*birth date (dd, mm)
drop a3_dd* a3_mm*

*caste
drop a5*

*permanent disability/ condition
drop f5*

*patient's height
drop t1*

*notes
drop notes*

*drop tb number
drop x1*

save "Data_3ie\Patient_survey\patient_survey.dta", replace

*COUNSELOR BASELINE

use "Counselor Surveys\Counselor_baseline\counselor_baseline_edit.dta", clear

*cneter_area_name
drop *c_area_name

*birth date( dd, mm)
drop *birth_dd *birth_mm

*center sub-area names
drop *center*_subarea_*

*name mentions

drop *center*_next_main_name
drop *center*_next_main*
drop *c*_visit_resp*

*notes
drop *notes*

save "Data_3ie\Counselor_survey\counselor_baseline.dta", replace

*COUNSELOR MIDLINE

use "Counselor Surveys\Counselor_midline\counselor_midline_edit.dta", clear

*birth date( dd, mm)
drop *birth_dd *birth_mm

*center sub-area names
drop *center*_subarea_*

*name mentions
drop *center*_next_main*
drop *c*_visit_resp*

*notes
drop *notes*

save "Data_3ie\Counselor_survey\counselor_midline.dta", replace

*COUNSELOR MIDLINE

use "Counselor Surveys\Counselor_midline_plus\counselor_midlineplus_edit.dta", clear

*birth date( dd, mm)
drop *birth_dd *birth_mm

*center sub-area names
drop *center*_subarea_*

*name mentions
drop *center*_next_main*
drop *c*_visit_resp*

*notes
drop *notes*

save "Data_3ie\Counselor_survey\counselor_midlineplus.dta", replace

*COUNSELOR ENDLINE

use "Counselor Surveys\Counselor_endline\counselor_endline_edit.dta", clear

*center sub-area names
drop *center*_subarea_*

*name mentions
drop *center*_next_main*
drop *c*_visit_resp*

*notes
drop *notes*

save "Data_3ie\Counselor_survey\counselor_endline.dta", replace

*COUNSELOR ENDLINEPLUS

use "Counselor Surveys\Counselor_endline_plus\counselor_endlineplus_edit.dta", clear

*center sub-area names
drop *center*_subarea_*

*name mentions
drop *center*_next_main*
drop *c*_visit_resp*

save "Data_3ie\Counselor_survey\counselor_endlineplus.dta", replace

*COUNSELOR SALARY/CENTERWISE DATA

use "Counselor Salary_Centerwise\CTM_Salary_Centerwise\City_Wise_Data\Counselor_Salary_Centerwise_v1.dta", clear

*dropping counselor names and comments
drop counselor	counselorname counselornameformerge comments*

save "Data_3ie\monthly_summary_salary_reports.dta", replace

